SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_CDS_PermissionsGetByTemplateAndType]
	@TemplateID int,
	@PermissionType tinyint
AS
BEGIN
	SELECT [ID], TemplateID, PermissionType, Scope
	FROM [DnnProduct_CDS_Permissions]
	WHERE TemplateID = @TemplateID AND PermissionType = @PermissionType
END
GO
